CREATE VIEW [dbo].[vSoaPartyItemPrice]
AS
SELECT     
      p.[PartyId],
      p.[Id] AS [Id],
      p.[Status] AS [PartyStatus],
      p.[Name] AS [PartyName],
    p.[Sort] AS [PartySort],
    p.[CityName] AS [PartyCityName],
    p.[CountrySubEntityName] AS [PartyCountrySubEntityName],
    p.[CountryName] AS [PartyCountryName],
    p.[Phone] AS [PartyPhone],
    p.[Email] AS [PartyEmail],
    p.[IsMarkedForDelete] AS [PartyIsMarkedForDelete],
    p.[LastName] AS [PartyLastName],
    p.[FirstName] AS [PartyFirstName],
    p.[OrganizationName] AS [PartyOrganizationName],
    p.[CustomerTypeCode] AS [CustomerTypeCode],  
    i.[ItemId],
    i.[ItemId] as [ProductCode],
    i.[Name] AS [ItemName],
    i.[Description] AS [ItemDescription],
    i.[ItemClass] AS [ItemClass],
    i.[PRICE_1] AS [ItemPrice1],
    i.[PRICE_2] AS [ItemPrice2],
    i.[PRICE_3] AS [ItemPrice3],
    i.[COMPLIMENTARY] AS [ItemComplimentary],
    i.[IS_KIT] AS [ItemIsKit],
    n.[MEMBER_RECORD] as [NameIsMember],
    i.[RegistrantClassProcedure] as [RegistrantClassProcedure]
FROM [dbo].[vSoaPartySummary] p
    INNER JOIN [dbo].[Name] n ON p.[Id] = n.[ID]
      CROSS JOIN [dbo].[vSoaItem] i

GO